FINAN509-23B (HAM)
Financial Modelling
15 Points
Staff
Convenor(s)
Peter Huang
9407
MSB.3.29
peter.huang@waikato.ac.nz
|
Administrator(s)
Librarian(s)
You can contact staff by:
- Calling +64 7 838 4466 select option 1, then enter the extension.
-
Extensions starting with 4, 5, 9 or 3 can also be direct dialled:
- For extensions starting with 4: dial +64 7 838 extension.
- For extensions starting with 5: dial +64 7 858 extension.
- For extensions starting with 9: dial +64 7 837 extension.
- For extensions starting with 3: dial +64 7 2620 + the last 3 digits of the extension e.g. 3123 = +64 7 262 0123.
What this paper is about
This paper enables students to understand financial modelling and its usefulness in financial decision making. It ensures that students have skills in financial problem solving from a corporate perspective using Excel functions and visual basic programming codes.
The objective of this paper is to equip students with financial modelling skills using a computer spreadsheet, including generic skills such as performing sensitivity analyses, running simulations and solving valuation problems in finance. The paper will also introduce students to more advanced programming techniques in financial modelling, including defining often used financial functions and performing complex tasks with Visual Basic programming codes.
How this paper will be taught
This is a “hands-on” paper with extensive use of computers and spreadsheets. Its general objective is to develop spreadsheet and management skills for creating computer-based models for analysing a variety of decision problems facing today’s financial managers and professionals. Therefore, I promote hybrid-style workshop classes (shown as tutorial in the following timetable). The two-hour workshop include one-hour lecture dealing with knowledge and skills and one-hour tutorial dealing with practical questions.
Workshops will be conducted on campus and will be recorded. Recordings will be uploaded to Moodle.
Learning materials are uploaded onto Moodle for students to download before workshops (lectures and tutorials).
Required Readings
Learning Outcomes
Students who successfully complete the course should be able to:
Assessments
How you will be assessed
http://www.waikato.ac.nz/sasd/examinations/exams3.shtml
The internal assessment/exam ratio (as stated in the University Calendar) is 100:0. There is no final exam.